//package net.jsoft.pms.mapper.versionplan;
//
//import java.util.Date;
//import java.util.List;
//
//import org.apache.ibatis.annotations.Mapper;
//import org.apache.ibatis.annotations.Param;
//import org.apache.ibatis.annotations.Select;
//
//import net.jsoft.pms.mapper.BaseMapper;
//import net.jsoft.pms.vo.plan.PlanTaskInfo;
//
//@Mapper
//public interface VersionPlanMapper extends BaseMapper
//{
//
//    //    @SelectProvider(type = VersionPlanProvider.class, method = "selectVersionPlan")
//    //    List<PlanTaskInfo> selectVersionPlan(@Param("start") Date start, @Param("end") Date end);
//    //
//    //    @SelectProvider(type = VersionPlanProvider.class, method = "selectVersion")
//    //    List<PlanTaskInfo> selectVersion(@Param("start") Date start, @Param("end") Date end);
//    @Select("SELECT DISTINCT EARLYVERSION FROM HX_ZGXT.DZSWJ_PLAN_LIST WHERE EARLYVERSION IS NOT NULL ORDER BY EARLYVERSION ASC")
//    List<String> selectVersions();
//
//    @Select("SELECT * FROM HX_ZGXT.DZSWJ_PLAN_LIST t WHERE t.earlystart >=  to_date('20170814','yyyymmdd') AND TYPE IN ('功能开发','接口开发','问题修复') AND EARLYVERSION IS NULL")
//    List<PlanTaskInfo> selectNoVersionPlanRisk();
//
//    @Select("SELECT * FROM HX_ZGXT.DZSWJ_PLAN_LIST t WHERE t.earlystart >=  to_date('20170814','yyyymmdd') AND TYPE IN ('功能开发','接口开发','问题修复') AND EARLYVERSION IS NOT NULL AND LATEVERSION IS NULL AND EARLYVERSION < #{nowVersion}")
//    List<PlanTaskInfo> selectDelayVersionPlan(@Param("nowVersion") String nowVersion);
//
//    @Select("SELECT * FROM HX_ZGXT.DZSWJ_VERSION_SEPCIALVERSION")
//    List<Date> selectSepcialVersionDate();
//
//    @Select("SELECT t.*, CASE WHEN t.lateversion IS NULL THEN '0'  ELSE '1' END PUBLISHFLAG FROM HX_ZGXT.DZSWJ_PLAN_LIST t WHERE TYPE IN ('功能开发','接口开发','问题修复') AND EARLYVERSION =  #{version}")
//    List<PlanTaskInfo> selectVersionPlan(@Param("version") String version);
//
//    @Select("SELECT t.*, CASE WHEN t.lateversion IS NULL THEN '0'  ELSE '1' END PUBLISHFLAG FROM HX_ZGXT.DZSWJ_PLAN_LIST t WHERE TYPE IN ('功能开发','接口开发','问题修复') AND LATEVERSION =  #{version}")
//    List<PlanTaskInfo> selectPulishVersion(@Param("version") String version);
//
//}
